Structure of database tables

The P&ID database includes the following fixed database tables, with some fixed database fields.

ARMATURES

The main table of ARMATURES. It can have as many sub-tables as needed.

PosId

PosId given by the user. It must be unique or empty.

Status

Indicates whether the record is currently being edited.

Revision

Internal revision ID.

TypeTbl

The name of the subtype (sub-table, like VESSELS).

Pipeline

The name of the pipeline to which the armature belongs.

MenuItmData

The prefix for the position ID and the lookup key for the COMPLOOKUP table.

Description

The description of the armature. Can be empty. This field is used in the integration to Plant Modeller and must exist.

DmPartCode

The OID of the COS object used in Plant Modeller.

PdObjectId

Unique object ID (OID).

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields.

Special columns in ARMATURES table are "Spec" and "InsulationSpec". If these are added and the pipeline has more than one specification as optional, the options can be selected for the part itself in the database editor.

Insulation specification can be set as required for the pipeline, and then all armatures inherit the specification automatically. If insulation is optional, it can be set for each pipe run and valve separately.

DUCTS

The main table of DUCTS.

Status

Indicates whether the record is currently being edited.

PdObjectId

Unique object ID (OID).

PosId

PosId given by the user. It must be unique or empty.

Revision

Internal revision ID.

TypeTbl

The name of the subtype (sub-table).

Ductline

The name of the ductline.

PdDuctlineOid

The OID of the ductline.

MenuItmData

The prefix for the position ID and the lookup key for the COMPLOOKUP table.

Description

The description of the ductline. Can be empty. This field is used in the integration to Plant Modeller and must exist.

DmPartCode

The OID of the COS object used in Plant Modeller.

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields.

EQUIPMENTS

The main table of EQUIPMENTS. It can have as many sub-tables as needed.

PosId

PosId given by the user. It must be unique or empty.

Status

Indicates whether the record is currently being edited.

Revision

Internal revision ID.

TypeTbl

The name of the subtype (sub-table, like VESSELS).

System

The name of the assigned system.

MenuItmData

The prefix for the position ID and the lookup key for the COMPLOOKUP table.

Description

The description of the equipment. Can be empty. This field is used in the integration to Plant Modeller and must exist.

model_status

 

model_not_set

If anything else than 0, the object is not in the model.

DmPartCode

The OID of the COS object used in Plant Modeller.

PdObjectId

Unique object ID (OID).

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields.

INSTRUMENTS

The main table of INSTRUMENTS. It can have as many sub-tables as needed.

PosId

PosId given by the user. It must be unique among all instrument position IDs or empty.

Status

Indicates whether the record is currently being edited.

Revision

Internal revision ID.

TypeTbl

The name of the subtype (sub-table, like VESSELS).

Tag

The name of the instrument tag to which the instrument belongs.

MenuItmData

Combination of attributes defined for the Diagram Object Template and the lookup key for the COMPLOOKUP table.

Location

The location of the instrument: local, control room, or local control panel.

MeasuredVar

The measured variable. Usually filled in via the Diagram Object Template.

Modifier

Initial value usually filled in via the Diagram Object Template.

Function

Initial value usually filled in via the Diagram Object Template.

Superscript

 

Subscript

 

Description

 

DmPartCode

 

PdObjectId

Unique object ID (OID).

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields.

EditObjsOfGd

Stores the information which objects are checked out in which diagram.

Diagram

The OID of the diagram.

PdObjectId

The OID of the object (system, pipeline, tag, equipment, armature, instrument).

NrOfObjects

The number of linked objects in the diagram.

EditedInThisDiagram

If this is a positive value, the object is edited in this checked out diagram.

PI_CATALOG

PI_CATALOG table stores the information of the diagram document itself and the title box of the document.

Note: Project administrator can edit the PI_CATALOG table in Database Table Manager—see Database Table Manager.

Name

The unique name for a diagram. Same as the base name of the files storing the graphical diagram.

Status

Indicates whether the record is currently being edited.

Type

Type of the diagram.

InUseBy

Identifies who has checked out the document.

Revision

Internal revision ID of the diagram. Counts how many times the diagram has been checked in.

PdObjectId

Unique object ID (OID) of the diagram.

PdTransactionNr

Internal counter that is incremented every time the diagram is saved. Used to control that the binary diagram and the database are synchronized.

Note: The PI_CATALOG table used to be called P&I_CATALOG. You do not have to change the name of the old table—the system handles it automatically.

PIPELINES

Stores the data of the pipelines. The data of the pipelines is stored both in the database and in the COS objects.

PosId

A unique ID given by the user.

Deleted

Flag indicating that this pipeline is to be deleted if no object is referring to it.

PipelineId

The same as PosId.

Status

Indicates whether the record is currently being edited.

Revision

Internal revision ID.

System

The name of the system of the pipeline.

PdObjectId

Unique object ID (OID).

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. If negative and PosId is not a null string, there is a conflict between PosIds and a new PosId must be provided.

Spec1-Spec5

The piping specifications 1–5.

AttrUseInDiagram

If this is 1, the pipeline can be used in P&ID.

AttrUseInModeller

If this is 1, the pipeline can be used in Plant Modeller.

AttrAddedInDiagram

If this is a positive value, the pipeline has been created or modified in P&ID but has not yet been updated to COS.

ReviseObjsOfDg

Stores information about which objects are checked in and in which diagram.

Diagram

OID of the diagram.

PdObjectId

OID of the object (system, pipeline, tag, equipment, armature, instrument).

NrOfObjects

The number of linked objects in the diagram.

OwnThisObject

 

SYSTEMS

Stores the data of the systems. The data of the systems is stored both in the database and in the COS objects, just like the pipelines.

PosId

A unique string ID given by the user.

Deleted

Flag indicating that this system is to be deleted if no object is referring to it.

Status

Indicates whether the record is currently being edited.

Revision

Internal revision ID.

SystemId

The same as PosId.

Pmsysno

The ID number Plant Modeller uses to identify its system.

Color

The color index number.

Width

Line width for symbols. This is given as the pen ID which maps to the line thickness on plots. See Lineweights.

Width_of_line

Line width for thin connection lines. If this value is 0, the same line width as for symbols is used.

Width_of_thickline

Line width for thick connection lines. If this value is 0, the same line width as for symbols is used.

Layer

The layer index for the graphics in this system.

LayerName

The name of the layer for document export. See Drawing export configuration

PdObjectId

Unique object ID (oid).

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields. If negative and PosId is not a null string, there is a conflict between PosIds and a new PosId must be provided.

AttrUseInDiagram

If this is 1, the system can be used in P&ID.

AttrUseInModeller

If this is 1, the system can be used in Plant Modeller.

AttrAddedInDiagram

If this is a positive value, the system has been created or modified in P&ID but has not yet been updated to COS.

TAGS

Stores the data of the instrument tags.

PosId

The unique ID given by the user.

Deleted

Flag indicating that this tag is to be deleted if no object is referring to it.

TagId

The same as Posid.

Status

Indicates whether the record is currently being edited.

Revision

Internal revision ID.

System

The name of the system of the instrument tag.

PdObjectId

Unique object ID (OID).

PosIdNull

If PosId is a null string, this is not zero. The unique PosId is a combination of PosId, Status, and PosIdNull fields. If negative and PosId is not a null string, there is a conflict between PosIds and a new PosId must be provided.